# -*- coding: utf-8 -*-
import json


#测试库企业证书计数
def getCompanyChangeList(request):
    request.cursor_33.execute(request.formatSql('''
        select old_company_name,final_company_name 
        from theme.company_change_mapping 
        where( old_company_name like '%${key}%' or final_company_name like '%${key}%')
        limit 100
    '''))
    rows = request.cursor_33.fetchall()
    return json.dumps(rows, ensure_ascii=False)